﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace Maticsoft.DAL
{
	/// <summary>
	/// 数据访问类:UA_Account
	/// </summary>
	public partial class UA_Account
	{
		public UA_Account()
		{}
		#region  BasicMethod

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
        {
            DbHelperSQLP db = new DbHelperSQLP(SqlHelper.UFSystemSQLConnString);
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select iSysID,cAcc_Id,cAcc_Name,cAcc_Path,iYear,iMonth,cAcc_Master,cCurCode,cCurName,cUnitName,cUnitAbbre,cUnitAddr,cUnitZap,cUnitTel,cUnitFax,cUnitEMail,cUnitTaxNo,cUnitLP,cFinKind,cFinType,cEntType,cTradeKind ");
			strSql.Append(" FROM UA_Account ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
            return db.Query(strSql.ToString());
		}

	

		#endregion  BasicMethod
		#region  ExtensionMethod

		#endregion  ExtensionMethod
	}
}

